<?php 

require ('../include/web.init.inc.php');
extract ( $_GET);
header("Content-type: application/json");
$current_user_info = UserSession::getSessionInfo();
$input_data = array ('user_name' => $user_name,'user_num'=>$user_num,'phone'=>$phone,'compose_id'=>$compose_id,
	'user_id'=>$current_user_info["user"]["id"]);
$module_id = Other::addComposeUser ( $input_data );

// if($user_info){
$ret = json_encode(array("code"=>1,"data"=>array('a' => 1)));
// }else{
// 	$ret = json_encode(array("code"=>0,"msg"=>"用户名密码错误"));
// }

echo $ret;

CREATE TABLE `tb_phone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

CREATE TABLE `tb_phone_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_id` int(11) NOT NULL,
  `card_id` int(11) NOT NULL,
  `end_time` timestamp NULL,
  `open_time` timestamp NULL,
  `open_phone` varchar(255) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

UPDATE `sms`.`osa_menu_url` SET `menu_name`='手机号管理', `menu_url`='/panel/phone.php' WHERE `menu_id`='121';

UPDATE `sms`.`osa_menu_url` SET `menu_name`='手机号', `menu_url`='/panel/phone_modify.php' WHERE `menu_id`='123';

UPDATE `sms`.`osa_menu_url` SET `menu_name`='修改日期', `menu_url`='/panel/sms_view.php' WHERE `menu_id`='124';

UPDATE `sms`.`osa_menu_url` SET `menu_name`='导入', `menu_url`='/panel/sms_input.php' WHERE `menu_id`='120';

ALTER TABLE `sms`.`card` 
ADD COLUMN `operator` VARCHAR(255) NULL AFTER `create_time`,
ADD COLUMN `channel` VARCHAR(255) NULL AFTER `operator`;

ALTER TABLE `sms`.`tb_phone_card` 
ADD COLUMN `end_time` VARCHAR(255) NULL AFTER `open_time`,
